|
|
| Book details / order |
| VBA AND MACROS: MICROSOFT EXCEL 2010 |
Use excel 2010 vba and macros to automate virtually any routine task, and save yourself hours, days, maybe even weeks. then learn how to make excel do things you thought were simply impossible! this book reveals scripting techniques you won’t find anywhere else and shows you how to create automated reports that are amazingly powerful and useful. it helps you instantly visualize information so you can understand and act on it. it also shows you how to capture data from anywhere and use it anywhere, and helps you automate excel 2010’s most powerful new features. learning advanced excel scripting has never been easier. you’ll find simple, step-by-step instructions, real-world examples and case studies, and 50 workbooks packed with bonus examples, macros, and solutions, straight from mrexcel.
-----------------------------
table of content
unleash the power of excel with vba
this sounds like basic, so why doesn’t it look familiar?
referring to ranges
user-defined functions
looping and flow control
r1c1-style formulas
what is new in excel 2010 and what has changed
create and manipulate names in vba
event programming
userforms: an introduction
creating charts
data mining with advanced filter
using vba to create pivot tables
excel power
data visualizations and conditional formatting
reading from and writing to the web
dashboarding with sparklines in excel 2010
automating word
arrays
text file processing
using access as a back end to enhance multiuser access to data
creating classes, records, and collections
advanced userform techniques
windows api
handling errors
customizing the ribbon to run macros
creating add-ins
salient features
the fastest, best way to go beyond the macro recorder and move up the excel vba learning curve
shows how to automate powerful new excel 2010 features such as sparklines
includes crucial information on making excel 2010 vba code work with older versions
co-authored by excel legend and microsoft mvp bill jelen ("mrexcel") as part of his new mrexcel's library series
Author : Bill jelen, tracy syrstad
Publication : Pearson
Isbn : 9788131764138
Store book number : 107
NRS 880.00
|
 |
|
|
|
|
|
|
|
| |
|
|
